from sqlalchemy import *

db = create_engine('sqlite:///stocks.db')
metadata = BoundMetaData(db)

dps_table = Table('dps',metadata,
                  Column('dp_id', Integer, primary_key = True),
                  Column('date', Date),
                  Column('open', String(16)),
                  Column('close', String(16)),
                  Column('high', String(16)),
                  Column('low', String(16)),
                  Column('volume', String(24)))
dps_table.create()

gps_table = Table('gps',metadata,
                  Column('gp_id', Integer, primary_key = True),
                  Column('code', String(10)),
                  Column('date', Date),
                  Column('open', String(16)),
                  Column('close', String(16)),
                  Column('high', String(16)),
                  Column('low', String(16)),
                  Column('volume', String(24)))
gps_table.create()
